/*-+-*****************************************************************************
 Copyright (C) 2009-2012 Oceanside Software Corporation (R)
 Dallas, Texas

 Author       : Jason T. Brower
 Purpose      : This file is part of a point-of-sale software package
                originally written for Table-Service Restaurants.
              
 Date         : July 8th of 2012
              
 History      : The application that this software file belongs to was 
                written over a 3-Year period.  The first version was written
                in C# .Net 3.5 using Windows Forms.  Being new to .Net at
                the time, I soon learned of Windows Presentation Foundation,
                liked the graphics capabilities and databinding so I
                migrated to WPF.  When the .Net 4.0 framework was released
                the application was migrated from 3.5 to 4.0. Now today,
                .Net 4.5 RC is out and I was already in process of migrating
                before I made this public.
                
Excuse Me     : Please excuse the coding style, it is not representative of
                my typical work.  During the three years I was under a very
                tight budget, constantly running out of funding and was 
                working 18 hour days hyped up on 5-Hour Energy.  The 
                design is not textbook.  It is monolythic because of
                previous issues I will not get into.  There are few comments
                in the code and the ones that are there may be incorrect.
                
What it is not: This is not the exact version that I took through PA-DSS 2.0
                nor is it the exact version running at my customer sites.
                I removed some details for security purposes including some
                encryption algorithms.  The reporting was removed because
                I was including a third party library that cannot be 
                published with this Open Source.
                
What it is    : This application has been running at high volume restaraunts
                for over a year.  It never freezes, crashes or does anything
                unexpected.  So long as it is built, installed and configured
                correctly, it is a strong system that we can all enhance.

Contact       : Please note that I can no longer work for free.  However, you
                can reach me at information@oceansidesw.com.                                                      

*********************************************************************************/
using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;

#if _LOCALDB
  using Oceanside.LocalDB;
#else
using Oceanside.RemoteDB;
#endif

#if _LOCALDB
  namespace Oceanside.LocalDB
#else
namespace Oceanside.RemoteDB
#endif
{
    public partial class HOUSE_ACCOUNT
    {
        public static decimal GetHistoricalGrandTotal(DominicaEntities context, HOUSE_ACCOUNT ha)
        {
            decimal historicalCharges = 0;
            try
            {
                ///We need to check the house accounts outstanding balance.
                var q = SHIFT.GlobalContext.HOUSE_TRANSACTIONS.Where(ht => ht.HouseAccountId == ha.Id);
                if (q.Any())
                {
                    foreach (HOUSE_TRANSACTION ht in q.ToList())
                    {
                        ORDER order = SHIFT.GlobalContext.ORDERS.Where(o => o.Id == ht.OrderId).FirstOrDefault();
                        if (order != null)
                        {
                            historicalCharges += order.EntireTableGrandTotal;
                        }
                    }
                }
            }
            catch (Exception ex)
            {
                Logging.LogException(ex);
            }
            return historicalCharges;
        }

        public static decimal GetHistoricalPaymentsTotal(DominicaEntities context, HOUSE_ACCOUNT ha)
        {
            decimal historicalPayments = 0;
            try
            {
                if (ha.TRANSACTIONS.Any())
                {
                    historicalPayments = ha.TRANSACTIONS.Sum(t => t.Base + t.Gratuity);
                }
            }
            catch (Exception ex)
            {
                Logging.LogException(ex);
            }
            return historicalPayments;
        }

        public bool CanAcceptChargeAmount(decimal amount, DominicaEntities context)
        {
            bool canCharge = false;
            try
            {
                if (this.HasNoHighLimit)
                {
                    canCharge = true;
                }
                else
                {
                    decimal futureBalance = (GetHistoricalGrandTotal(context, this) + amount) - GetHistoricalPaymentsTotal(context, this);

                    if (futureBalance <= this.AccountLimit)
                    {
                        canCharge = true;
                    }
                }
            }
            catch (Exception ex)
            {
                Logging.LogException(ex);
            }
            return canCharge;
        }
    }
}
